The object of this lab is to gain some familiarity with dimensional modelling


Import this csv file into mysql through the MySQL Workbench import wizard:
https://www.benivade.com/insurance.csv

Take a look at the data in the table.

In the MySQL workbench modeller, consider how you might create a dimensional model for this data

You want the resulting schema to be of the "star" format

For simplicity, you may just create a subset of the tables required.

See here for more info on dimensional modelling:
https://medium.com/@kmsbmadhan/dimensional-modelling-visualization-of-northwind-database-beaac7fecb20

e.g.
FactInsurance
AgeDim
GenderDim
RegionDim

How would you migrate the data from the table created when the csv was imported into the new schema?